package com.lanp.gencode.test;

import java.math.BigDecimal;

public class SQLT {
    static String s =
            "SELECT id orderId\\, order_code orderCode\\, seller_id seller_id\\, buyer_id buyer_id\\, buyer_account_id buyer_account_id\\, seller_name sellerName\\, order_time orderTime\\, order_price orderPrice\\, actual_price actualPrice\\, pay_type payType\\, pay_code payCode\\, timeout_time timeOutTime\\, `status` orderState\\, cancel_cause cancelCause\\, confirm_time confirmTime\\, order_type order_type\\, send_type send_type\\, `status`\\, receivable\\, pay_time\\, postage\\, consignee_name\\, consignee_phone\\, order_agent\\, order_agent_account_id\\, warehouse_id\\, shipping_type\\, warehouse_address\\, warehouse_phone FROM main_order WHERE buyer_id = 666431880507520 AND `status` IN ('sending') AND consignee_name LIKE concat('%'\\, '鐜嬮挵闈?\\, '%') order by order_time desc LIMIT 20";

    public static void main(String[] args) {
        s = s.replaceAll(" ", " ")
                .replaceAll("\\\\,", ",")
                .replaceAll("\\\\n", "\n");
        System.out.println(s);
    }
}
